
Source Table Structures
Table
Name
No of
Fields
Description
AHD 25 Additional Health Data: lifestyle data, preventative healthcare,
immunizations, test results and death details.
Consult
9 Practice consultations with date, time and duration.
Dosage
3 Prescribed dosage
Medical
22 Records of symptoms, diagnoses and interventions recorded by the
primary care team.
Pack
8 Links to the Therapy table when a quantity is low, meaning the GP may
have prescribed in packs.
Pack_siz
e
2 Links to the Therapy table when a quantity is low, meaning the GP may
have prescribed in packs.
Patient
18 Information on patient characteristics and registration details.
Staff
4 Specific roles of the practice staff
Therapy
24 Prescriptions issued to patients
Thin_pra
c
9 Created for updates and provides a summary of information in each
practice
Table
Name
No of
Fields
Description
DAFR,
Back_Offic
e_data
27 All data is stored in this one table
NDF
Reference
file
37 Reference file to drugs in back_office_data.
Reference
file for
tests
5 Results or tests for patients in back_office_data
Doctor
Attributes
6 Provider level specifics
Source Data Tables No of
Fields
Description
Practice 16 Practice level information including specialties.
Patient
19 All documented patients and their demographic data.
Diagnosis
22 ICD -10 codes included in the data
Diagnosis Event Text
3 Additional Diagnosis Event Information
Therapy
47 WHO ATC5 level
Problem Events
6 All documented diagnosis/problem level data, like other_event tables
descriptions.
Prescription Evevnts
21 All documented prescription level data.
Test Prevention Events
21 All documented test level with units and value data
Adipositas Smoking Events
8 All documented obesity and smoking status
Action Events
8 All documented “notes” from physician (i.e. referrals, sick leave,
hospitalization, etc.